﻿CREATE TABLE [Core].[Domain] (
    [DomainId]             UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [DomainName]           NVARCHAR (127)   NOT NULL,
    [SiteTitle]            NVARCHAR (127)   NOT NULL,
    [IsMultiBUYN]          NCHAR (1)        NOT NULL,
    [SMTPFrom]             NVARCHAR (127)   NULL,
    [SMTPServer]           NVARCHAR (127)   NULL,
    [SMTPPort]             NVARCHAR (5)     NULL,
    [SMTPUseSSLYN]         NCHAR (1)        NULL,
    [SMTPAccount]          NVARCHAR (127)   NULL,
    [SMTPPassword]         NVARCHAR (127)   NULL,
    [SMTPAllowSendYN]      NCHAR (1)        NOT NULL,
    [EnableSelfRegisterYN] NCHAR (1)        NOT NULL,
    [ThemeId]              UNIQUEIDENTIFIER NOT NULL,
    [ReCaptchaPublicKey]   NVARCHAR (127)   NULL,
    [ReCaptchaPrivateKey]  NVARCHAR (127)   NULL,
    [PrimaryBU]            UNIQUEIDENTIFIER NOT NULL,
    [SubscriptionLevel]    NCHAR (1)        NOT NULL,
    [IsDroppedYN]          NCHAR (1)        NOT NULL,
    [CreateDT]             DATETIME         NOT NULL,
    [CreatedById]          UNIQUEIDENTIFIER NOT NULL,
    [CreatedByName]        NVARCHAR (127)   NOT NULL,
    [ModifiedDT]           DATETIME         NOT NULL,
    [ModifiedById]         UNIQUEIDENTIFIER NOT NULL,
    [ModifiedByName]       NVARCHAR (127)   NOT NULL
);

